********************************************************************************
* appendix tables 2: mean 1br rent by msa and year

********************************************************************************

cd "$main_dir/data"

use unique_listings, clear
rename leasepricedollarcnt rent
winsor2 rent, cuts(1 99) replace
drop if year==2012

gen rent_1br=rent
replace rent_1br=. if bedroomcnt!=1
collapse (mean) rent_1br, by(met year)
order met year rent_1br*

bro
